﻿





using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;

namespace Picea.Data
{
    public class TipoLogradouroDAO
    {
        public static List<string> RetornaTipoLogradouro()
        {
            const string comando = "SELECT stTipoLogradouro FROM TB_TIPO_LOGRADOURO;";

            List<string> lstRetorno = new List<string>();

            using (SqlCeDataReader reader = SqlHelper.ExecuteReader(SqlHelper.PiceaConnection, comando))
            {
                
                while (reader.Read())
                {
                    lstRetorno.Add(reader["stTipoLogradouro"].ToString());
                }

                return lstRetorno;
            }
        }
    }
}
